To currency operator

Crystal syntax.

Usage

$x

Converts x from number to currency.

Examples

The following examples are applicable to Crystal syntax.

Note:    Each example assumes you have selected the following format options on the Number tab of the Format Editor: Decimal places = (1.00), Negative sign = (345.00-), Currency symbol = (Float), and Thousands Separator = (1,000.00).

$12345678

Returns $12,345,678.00.

$(123 * 456)

Returns $56,088.00

$({file.QUANTITY} * 3)

Returns $42.00, where {file.QUANTITY} = 14.

$({file.MILES} * {file.PLEDGE})

$27.95, where {file.MILES} = 13 and {file.PLEDGE} = 2.15.

Note:    $ * $ = error. You can not multiply a dollar with a dollar.

Related topics

Formula 5



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com